Create Procedure CreateUserAccount(
@UserName varchar(30),
@Password varchar(30),
@EMailAddr varchar(50),
@SecretQuestion varchar(50),
@SecretAnswer varchar(50),
@IsApproved bit)
as
begin
declare @DOB datetime
set @DOB=CONVERT( datetime, '17540101', 112 )
declare @LastLogin datetime
set @LastLogin=convert(datetime, '17540101',112)
end
Insert into CreateUserAccount(
UserName,
Password,
DOB,
EMailAddr,
SecretQuestion,
SecretAnswer,
LastLogin,
IsApproved) Values(
@UserName,
@Password,
@DOB,
@EMailAddr,
@SecretQuestion,
@SecretAnswer,
@LastLogin,
@IsApproved)